package com.example.finance_oa.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.comment_oa.pojos.Amount;
import com.example.comment_oa.pojos_vo.AmountVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
* @author Jin
* @description 针对表【amount】的数据库操作Mapper
* @createDate 2022-10-18 15:59:05
* @Entity com.example.finance_oa.pojos.Amount
*/
@Mapper
public interface AmountMapper extends BaseMapper<Amount> {
    List<Amount> allAmount(AmountVo amountVo);
    //查询未付款金额
    List<Amount>  sumamountMoney1(int empId);

    //查询已付款金额
    List<Amount>  sumamountMoney2(int empId);

    //新增报销主表
    int insertAll(@Param("amountProcess")String amountProcess, @Param("amountTitle")String amountTitle, @Param("amountTime")Date amountTime
            , @Param("deptName")String deptName, @Param("empId")Integer empId, @Param("amountState")Integer amountState,
                  @Param("amountMoney")Double amountMoney, @Param("empCard")String empCard,@Param("empName")String empName);


    //根据流程编号查询报销详情
    List<Amount> amountXb(String amountProcess);



    //根据流程编号修改他的状态
    int updateAmountState(@Param("amountState") Integer amountState,@Param("amountProcess")String amountProcess);






}




